Microsoft Access 2013 Study Guide

             Microsoft Office Specialist (MOS): Exam 77-424 for Access 2013

1.0 Create and Manage a Database
1.2 Manage Relationships and Keys
Relationships: Create and Modify Relationships, Pg 80
Relationships: Enforce Referential Integrity, Pg 81
Relationships: Set Foreign Keys, Pg 39
Relationships: View Relationships, Pg 76

1.4 Protect and Maintain a Database
Protect and Maintain: Compact, Pg 341
Protect and Maintain: Repair, Pg 341
Protect and Maintain: Backup, Pg 292
Protect and Maintain: Split, Pg 326
Protect and Maintain: Encrypt with a Password, Pg 335

1.5 Print and Export a Database
Print and Export: Print Reports, Pg 336
Print and Export: Save Database to an External Location, Pg 316
Print and Export: Export into Alternate Formats, Pg 255

 

2.0 Build Tables
2.1 Create Tables
Tables: Create a Table, Pg 73
Tables: Create Linked Tables from External Sources, Pg 322

2.2 Format a Table
Tables: Format a Table, Pg 57
Tables: Hide Fields, Pg 56
Tables: Change Data Format, Pg 296

2.3 Manage Records
Manage Records: Update Records, Pg 45
Manage Records: Append Records, Pg 282
Manage Records: Group Records, Pg 165

2.4 Create and Modify Fields
Tables: Change Field Data Types, Pg 296